package com.sl.au.repository;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import com.sl.au.entity.EXDELoginInfo;

public interface EXDELoginInfoRepository extends JpaRepository<EXDELoginInfo, Long> {
	EXDELoginInfo getByUserNameAndPassword(String userName,String password);
	/**找到没有角色配置的视图用户，用于系统中新增用户
	 * @return
	 */
	@Query("select l from EXDELoginInfo l where l.empId "
			+ "  not in( select u.id from User u where u.id is not null)")
	List<EXDELoginInfo> getNoRole();
}
